﻿CREATE TYPE [dbo].[udtUsers] AS TABLE (
    [UserID] INT NOT NULL,
    PRIMARY KEY CLUSTERED ([UserID] ASC));


GO
GRANT CONTROL
    ON TYPE::[dbo].[udtUsers] TO PUBLIC;


GO
GRANT REFERENCES
    ON TYPE::[dbo].[udtUsers] TO PUBLIC;


GO
GRANT TAKE OWNERSHIP
    ON TYPE::[dbo].[udtUsers] TO PUBLIC;


GO
GRANT VIEW DEFINITION
    ON TYPE::[dbo].[udtUsers] TO PUBLIC;


GO
GRANT CONTROL
    ON TYPE::[dbo].[udtUsers] TO [verwaltung];


GO
GRANT REFERENCES
    ON TYPE::[dbo].[udtUsers] TO [verwaltung];


GO
GRANT TAKE OWNERSHIP
    ON TYPE::[dbo].[udtUsers] TO [verwaltung];


GO
GRANT VIEW DEFINITION
    ON TYPE::[dbo].[udtUsers] TO [verwaltung];

